pgAdmin Runtime Environment
--------------------------------------------------------
Python Path: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\python.exe"
Runtime Config File: "C:\Users\UKA018\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\config.py"
Webapp Path: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgAdmin4.py"
pgAdmin Command: "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\python.exe -s C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgAdmin4.py"
Environment: 
  - ALLUSERSPROFILE: C:\ProgramData
  - APPDATA: C:\Users\UKA018\AppData\Roaming
  - ATERNITY_AGENT_HOME: C:\Program Files (x86)\Aternity Information Systems\Agent\
  - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_22312_HVISENLIGFZKSGGW
  - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch now?|LEFT_TO_RIGHT
  - CommonProgramFiles: C:\Program Files\Common Files
  - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
  - CommonProgramW6432: C:\Program Files\Common Files
  - COMPUTERNAME: MMD5CG2523JG1
  - ComSpec: C:\windows\system32\cmd.exe
  - DriverData: C:\Windows\System32\Drivers\DriverData
  - HOMEDRIVE: C:
  - HOMEPATH: \Users\UKA018
  - JAVA_TOOL_OPTIONS: -agentpath:"C:\windows\system32\Aternity\Java\JavaHookLoader.dll"="C:\ProgramData\Aternity\hooks"
  - LOCALAPPDATA: C:\Users\UKA018\AppData\Local
  - LOGONSERVER: \\MMD5CG2523JG1
  - NUMBER_OF_PROCESSORS: 8
  - OneDrive: C:\Users\UKA018\OneDrive - Maersk Group
  - OneDriveCommercial: C:\Users\UKA018\OneDrive - Maersk Group
  - OnlineServices: Online Services
  - OS: Windows_NT
  - Path: C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\runtime;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\windows\System32\OpenSSH\;C:\Users\UKA018\AppData\Local\Microsoft\WindowsApps;
  - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  - PGADMIN_INT_KEY: b866f914-fa1d-4968-9d3d-dc3b9ce915dc
  - PGADMIN_INT_PORT: 54599
  - PGADMIN_SERVER_MODE: OFF
  - platformcode: AN
  - PROCESSOR_ARCHITECTURE: AMD64
  - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 140 Stepping 1, GenuineIntel
  - PROCESSOR_LEVEL: 6
  - PROCESSOR_REVISION: 8c01
  - ProgramData: C:\ProgramData
  - ProgramFiles: C:\Program Files
  - ProgramFiles(x86): C:\Program Files (x86)
  - ProgramW6432: C:\Program Files
  - PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft Azure Information Protection\Powershell
  - PUBLIC: C:\Users\Public
  - RegionCode: APJ
  - SESSIONNAME: Console
  - STEELCENTRAL_ATERNITY_AGENT_HOME: C:\Program Files (x86)\Aternity Information Systems\Agent\
  - SystemDrive: C:
  - SystemRoot: C:\windows
  - TEMP: C:\Users\UKA018\AppData\Local\Temp
  - TMP: C:\Users\UKA018\AppData\Local\Temp
  - USERDNSDOMAIN: CRB.APMOLLER.NET
  - USERDOMAIN: CRB
  - USERDOMAIN_ROAMINGPROFILE: CRB
  - USERNAME: UKA018
  - USERPROFILE: C:\Users\UKA018
  - windir: C:\windows
  - ZES_ENABLE_SYSMAN: 1
--------------------------------------------------------

Total spawn time to start the pgAdmin4 server: 0.837 Sec
2023-09-26 16:57:37,050: ERROR	pgadmin:	Database migration failed

2023-09-26 16:57:37,057: ERROR	pgadmin:	Traceback (most recent call last):
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 691, in drop_constraint
    const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
    db_upgrade(app)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\command.py", line 399, in upgrade
    script.run_env()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\script\base.py", line 578, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 93, in load_python_file
    module = load_module_py(module_id, path)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 109, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>
    run_migrations_online()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 937, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 624, in run_migrations
    step.migration_fn(**kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\migrations\versions\7c56ea250085_.py", line 26, in upgrade
    with op.batch_alter_table("server") as batch_op:
  File "contextlib.py", line 142, in __exit__
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\base.py", line 375, in batch_alter_table
    impl.flush()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 159, in flush
    fn(*arg, **kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 702, in drop_constraint
    raise ValueError("No such constraint: '%s'" % const.name)
ValueError: No such constraint: 'ck_port_range'


Traceback (most recent call last):
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 691, in drop_constraint
    const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 390, in upgrade_db
    db_upgrade(app)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\db_upgrade.py", line 25, in db_upgrade
    flask_migrate.upgrade(migration_folder)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\flask_migrate\__init__.py", line 200, in upgrade

    command.upgrade(config, revision, sql=sql, tag=tag)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\command.py", line 399, in upgrade
    script.run_env()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\script\base.py", line 578, in run_env
    util.load_python_file(self.dir, "env.py")
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 93, in load_python_file
    module = load_module_py(module_id, path)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\util\pyfiles.py", line 109, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 95, in <module>

    run_migrations_online()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\setup\..\..\migrations\env.py", line 87, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\environment.py", line 937, in run_migrations
    self.get_context().run_migrations(**kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\runtime\migration.py", line 624, in run_migrations
    step.migration_fn(**kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\migrations\versions\7c56ea250085_.py", line 26, in upgrade
    with op.batch_alter_table("server") as batch_op:
  File "contextlib.py", line 142, in __exit__

  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\base.py", line 375, in batch_alter_table
    impl.flush()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 159, in flush
    fn(*arg, **kw)
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 702, in drop_constraint
    raise ValueError("No such constraint: '%s'" % const.name)
ValueError: No such constraint: 'ck_port_range'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgAdmin4.py", line 104, in <module>
    app = create_app()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 477, in create_app

    run_migration_for_sqlite()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 436, in run_migration_for_sqlite
    upgrade_db()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 395, in upgrade_db
    backup_db_file()
  File "C:\Users\UKA018\AppData\Local\Programs\pgAdmin 4\v7\web\pgadmin\__init__.py", line 372, in backup_db_file
    os.rename(SQLITE_PATH, backup_file_name)
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\UKA018\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\UKA018\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20230926165737'